inherited frmInvoiceList: TfrmInvoiceList
  Left = 438
  Top = 120
  Caption = #24320#31080#31649#29702
  PixelsPerInch = 96
  TextHeight = 12
  inherited Panel1: TPanel
    inherited labFuncName: TcxLabel
      Style.IsFontAssigned = True
    end
    inherited labFuncDesc: TcxLabel
      Style.IsFontAssigned = True
    end
    inherited chkGridFilter: TcxCheckBox
      ExplicitWidth = 72
    end
    inherited edtSDate: TcxDateEdit
      ExplicitHeight = 20
    end
    inherited edtEDate: TcxDateEdit
      ExplicitHeight = 20
    end
  end
  inherited pnlMain: TPanel
    inherited MainDataGrid: TcxGrid
      inherited MainDataGridDBTableView: TcxGridDBTableView
        OptionsBehavior.IncSearch = False
        OptionsView.FooterMultiSummaries = True
        object MainDataGridDBTableViewtradername: TcxGridDBColumn [2]
          DataBinding.FieldName = 'name'
          HeaderAlignmentHorz = taCenter
          Width = 120
        end
        object MainDataGridDBTableViewinver: TcxGridDBColumn [3]
          DataBinding.FieldName = 'inver'
          HeaderAlignmentHorz = taCenter
          Width = 80
        end
        object MainDataGridDBTableViewcheckno: TcxGridDBColumn [4]
          DataBinding.FieldName = 'checkno'
          HeaderAlignmentHorz = taCenter
          Width = 100
        end
        inherited MainDataGridDBTableViewamount: TcxGridDBColumn
          Width = 80
        end
        object MainDataGridDBTableViewinvtypename: TcxGridDBColumn [7]
          DataBinding.FieldName = 'invtypename'
          HeaderAlignmentHorz = taCenter
          Width = 80
        end
        object MainDataGridDBTableViewbkindname: TcxGridDBColumn [8]
          DataBinding.FieldName = 'bkindname'
          HeaderAlignmentHorz = taCenter
          Width = 80
        end
        inherited MainDataGridDBTableViewfilname: TcxGridDBColumn
          DataBinding.FieldName = 'filid'
          Width = 80
        end
      end
    end
  end
  inherited MainDataSource: TDataSource
    Top = 91
  end
  inherited PopupMenu1: TPopupMenu
    inherited PopmnuModifyRecord: TMenuItem
      Visible = False
    end
  end
  inherited qyTmpDataSet: TUniQuery
    Left = 322
    Top = 130
  end
  inherited MainDataSetU: TUniQuery
    SQL.Strings = (
      'select m.bid, m.bkind, m.bstate, m.bcode, m.bdate, m.invtype,'
      'm.filid, m.traderid, m.deptid, m.empid, m.create_by, m.check_by,'
      
        'm.relationcount, m.amount, m.checkno, m.update_time, m.remark, m' +
        '.inver,'
      'k1.kname bkindname, k2.kname invtypename, t.name tradername,'
      'e.em_name empname from tb_invoice m'
      'left join ts_kind k1 on (m.bkind=k1.kid and k1.kind=5001)'
      'left join ts_kind k2 on (m.invtype=k2.kid and k2.kind=5002)'
      'left join td_trader t on m.traderid=t.traderid'
      'left join td_empmaster e on m.empid=e.em_employeeid'
      'where 1=1')
    Options.AutoPrepare = False
    object MainDataSetUbid: TIntegerField
      FieldName = 'bid'
    end
    object MainDataSetUbkind: TIntegerField
      DisplayLabel = #24320#31080#31867#22411
      FieldName = 'bkind'
    end
    object MainDataSetUbstate: TIntegerField
      FieldName = 'bstate'
    end
    object MainDataSetUbcode: TStringField
      DisplayLabel = #21333#21495
      FieldName = 'bcode'
      Size = 30
    end
    object MainDataSetUbdate: TDateTimeField
      DisplayLabel = #26085#26399
      FieldName = 'bdate'
    end
    object MainDataSetUinvtype: TIntegerField
      DisplayLabel = #24320#31080#26041#24335
      FieldName = 'invtype'
    end
    object MainDataSetUfilid: TIntegerField
      FieldName = 'filid'
    end
    object MainDataSetUtraderid: TIntegerField
      FieldName = 'traderid'
    end
    object MainDataSetUdeptid: TIntegerField
      FieldName = 'deptid'
    end
    object MainDataSetUempid: TIntegerField
      FieldName = 'empid'
    end
    object MainDataSetUcreate_by: TIntegerField
      FieldName = 'create_by'
    end
    object MainDataSetUcheck_by: TIntegerField
      FieldName = 'check_by'
    end
    object MainDataSetUrelationcount: TByteField
      FieldName = 'relationcount'
    end
    object MainDataSetUamount: TFloatField
      DisplayLabel = #24320#31080#37329#39069
      FieldName = 'amount'
    end
    object MainDataSetUcheckno: TStringField
      DisplayLabel = #21457#31080#21495
      FieldName = 'checkno'
      Size = 30
    end
    object MainDataSetUupdate_time: TDateTimeField
      FieldName = 'update_time'
    end
    object MainDataSetUremark: TStringField
      DisplayLabel = #22791#27880
      FieldName = 'remark'
      Size = 200
    end
    object MainDataSetUinver: TStringField
      DisplayLabel = #24320#31080#20154
      FieldName = 'inver'
      Size = 60
    end
    object MainDataSetUbkindname: TStringField
      DisplayLabel = #24320#31080#31867#22411
      FieldName = 'bkindname'
      Size = 50
    end
    object MainDataSetUinvtypename: TStringField
      DisplayLabel = #24320#31080#26041#24335
      FieldName = 'invtypename'
      Size = 50
    end
    object MainDataSetUname: TWideStringField
      DisplayLabel = #24448#26469#21333#20301
      FieldName = 'name'
      Size = 60
    end
    object MainDataSetUem_name: TWideStringField
      FieldName = 'em_name'
      Size = 60
    end
  end
end
